day=`date +%Y%m%d`
echo $day
#hive -hivevar dt=$day -f ./import.hql
#hive -e "use mydb;"
path="/user_clicks/$day/clicklog.dat"
echo $path
sql="use mydb;LOAD DATA INPATH '${path}' INTO TABLE user_clicks PARTITION (dt = '${day}');"
echo $sql
hive -e "${sql}"
